SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
GO

PRINT '---- DROP TABLES'

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblVolunteerTasks' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblVolunteerTasks
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblTasks' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblTasks
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblContributionDiscountMember' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblContributionDiscountMember
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblContributionDiscounts' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblContributionDiscounts
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tbldiscounttype' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tbldiscounttype
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblContributionFees' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblContributionFees
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblInvoices' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblInvoices
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblCards' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblCards
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblKindOfCards' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblKindOfCards
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblMatchReferees' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblMatchReferees
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblMatchRefereeRoles' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblMatchRefereeRoles
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblMatchPlayers' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblMatchPlayers
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblMatches' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblMatches
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblTeamMembers' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblTeamMembers
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblTeams' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblTeams
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblPools' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblPools
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblClasses' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblClasses
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblKindsOfTeams' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblKindsOfTeams
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblSeasons' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblSeasons
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblFields' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblFields
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblKindOfFields' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblKindOfFields
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblComplex' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblComplex
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblChairmen' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblChairmen
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblMembersAdmin' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblMembersAdmin
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblOfficialScorer' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblOfficialScorer
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblTechnicalCommissioner' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblTechnicalCommissioner
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblOfficialsCommissioner' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblOfficialsCommissioner
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblPersons' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblPersons
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblPersonState' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblPersonState
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblSexes' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblSexes	
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblFamilies' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblFamilies
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblClubs' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblClubs
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblprovince' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblProvince
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tblFederation' AND TABLE_TYPE = 'BASE TABLE')
	DROP TABLE dbo.tblFederation
GO